USE [ORSDATABASE]
GO

/****** Object:  Table [dbo].[tb_paperinfo]    Script Date: 09/03/2011 15:21:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tb_paperinfo](
	[paperid] [int] IDENTITY(1,1) NOT NULL,
	[tiltle] [nvarchar](50) NULL,
	[authorid] [nchar](12) NULL,
	[interestid] [int] NULL,
	[reviewer] [nchar](12) NOT NULL,
	[description] [nvarchar](100) NULL,
	[contentlink] [nchar](50) NULL,
	[submitdate] [datetime] NULL,
	[sublimitdate] [datetime] NULL,
	[reviewstate] [int] NULL,
	[reviewlimitdate] [datetime] NULL,
	[approvestate] [int] NOT NULL,
 CONSTRAINT [PK_tb_paperinfo] PRIMARY KEY CLUSTERED 
(
	[paperid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tb_paperinfo] ADD  CONSTRAINT [DF_tb_paperinfo_reviewer]  DEFAULT (N'尚未指定') FOR [reviewer]
GO

ALTER TABLE [dbo].[tb_paperinfo] ADD  CONSTRAINT [DF_tb_paperinfo_approvestate]  DEFAULT ((0)) FOR [approvestate]
GO

